Exploring the Global Impact of Pandemics: A Data-Driven Analysis with a Focus on COVID-19
Introduction:
Welcome to my data-driven blog exploring the global impact of pandemics, with a specific focus on COVID-19. As the world continues to grapple with the far-reaching effects of infectious diseases, understanding the historical context and contemporary challenges posed by pandemics is paramount. Through comprehensive data analysis, we aim to shed light on the magnitude of past pandemics, the evolving landscape of COVID-19, and the socio-demographic factors influencing disease outcomes.
In the initial segment of this blog, we utilised data sourced from Wikipedia via Web-Scraping, which catalogs epidemics and pandemics alongside their respective dates and death tolls. While the quality of this data was commendable, it necessitated extensive manual cleaning to ensure numerical accuracy for analysis. Additionally, due to the dataset encompassing events dating back to 1350 BC, there were instances of missing data, denoted as NaN, as well as inaccuracies and broad ranges. To address these discrepancies, we opted to impute missing values with NaN and, where applicable, employed methods such as averaging to mitigate the impact of broad data ranges on our analysis.
First let's explore the pandemics with the largest impact by Death toll.
At a glance, we observe that the Black Death had the highest death toll, approximately 137.5 million people. Notably, the COVID-19 pandemic ranks among the top 10, underscoring its historic significance in recent times with an approximate death toll of 7 million. Additionally, the ongoing HIV/AIDS epidemic has a profound impact, with an approximate death toll of 42 million, highlighting its enduring significance.
Next, let's examine the lowest impact per death toll.
The Lowest Death Toll by Event provides an overview of events with the least significant death tolls. For example, the Queensland 2009 dengue outbreak resulted in only 1 fatality, while the 2006 India malaria outbreak saw an estimated 17 deaths. These instances may indicate diseases that are less contagious, occurred in sparsely populated areas, or where effective preventive measures were implemented.
Next I wanted to look at the impact of Pandemics over time to the present day:
Examining significant events and their respective death tolls between 1350 and 1800 reveals distinctive spikes in mortality. The first major spike occurred during the Cocoliztli epidemic of 1545-1548, which ravaged Central Mexico and led to approximately 10 million deaths. Following this devastating event, another surge in fatalities was observed during the Cocoliztli epidemic of 1576, resulting in approximately 2.5 million deaths.
In 1616, the New England infections epidemic emerged, claiming the lives of an estimated 2 million individuals. The graph further depicts a notable increase in mortality during the 1772 North American measles epidemic, coinciding with the 1772-1773 Persian Plague, collectively resulting in just over 2 million deaths.
The second graph reveals a notable spike caused by the 1855 Norfolk yellow fever epidemic, which was a consequence of the Third Plague pandemic. This devastating event, occurring in 1855, resulted in the tragic loss of approximately 13.5 Million lives. The Third Plague pandemic, originating in China in the mid-19th century, spread globally, causing widespread mortality.
Additionally, throughout the 19th century, several cholera pandemics inflicted a significant death toll. The first notable surge occurred in 1846, claiming approximately 1 million lives worldwide. Following this, the Fourth cholera pandemic in 1863 led to the deaths of around 600,000 individuals. Towards the end of the century, in 1899, the 6th cholera pandemic caused an estimated 800,000 deaths, marking the end to the century's battle against infectious disease. These pandemics underscore the profound impact of infectious diseases on human populations during the 19th century, shaping public health policies and practices for generations to come.